Purchase Register Detailed - Cross Tab
Logic ERP has added two new columns, PARTY USER CODE and PO SUPPLIER ORDER NO., to the Purchase Register Detailed - Cross Tab. This release also corrects ACCOUNT CODE and several columns that stayed blank when chosen on their own.
Step 1: Open the Report
Navigate to Reports/Queries and select Purchase Reports.
Open the Purchase Register Detailed - Cross Tab.
Step 2: PARTY USER CODE column
Add the PARTY USER CODE column from the report's column settings, then tick it.
It shows the party's user code beside the party name, the same as in the Sale Register - Cross Tab.
Step 3: PO SUPPLIER ORDER NO. column
Add the PO SUPPLIER ORDER NO. column from the report's column settings, then tick it.
It shows the supplier's order number from the purchase order behind each purchase.
Like PO ORDER NO., it fills only when Configuration > Report Consolidation > Document No. is ticked.
When a purchase comes from more than one purchase order, the supplier order numbers are listed in the same order as PO ORDER NO., one for each order, separated by commas. An order without a supplier order number leaves an empty place in the list. The column stays blank when none of the orders has a supplier order number.
The column fills even when it is the only purchase order column chosen.
What's corrected
ACCOUNT CODE now shows the account code of the party. Before, it showed the party's user code, which is now in the new PARTY USER CODE column. On rows with no party, ACCOUNT CODE now shows 0 instead of blank, the same as in the Sale Register - Cross Tab. This is intended.
With Document No. ticked, TRANSPORT MODE, PARTY BILL DATE, CHALLAN NO., CHALLAN DATE, CASES and VEHICLE NO. no longer stay blank when they are chosen without any of the other goods receipt columns, such as G.R. NO. or TRANSPORT.