This chapter contains these topics:
You can ensure the accuracy of your sales transaction records by reviewing the G/L entries that the Update Customer Sales program creates before you post them to the sales journals.
The Update Customer Sales program groups transactions into different types of batches for posting to journals:
Batch Type | Postings |
---|---|
Customer sales (batch type I) | Posts the sales, cost of goods sold, and inventory entries to the Customer Sales Journal. |
Inventory/COGS (batch type G) | Posts to the Inventory/COGS Journal. |
Interbranch sales (batch type ST) | Posts to the Branch Sales Journal and includes offsetting entries for revenue only if you include interbranch sales in the update. |
Intercompany sales (batch type V) | Posts to the Voucher Journal and debits the inventory accounts and credits the payables accounts for the selling branch/plant. |
You can review the information in each batch at three different levels:
Review Type | Information Displayed |
---|---|
General batch review | Displays batches by user ID, batch status, batch number, and entry date range. |
Detailed batch review | Displays journal entry header information, such as invoice number, document type, and gross amount for a single batch. |
Individual journal entries review | Displays journal entry detail information, such as the amount charged to a cost of goods sold, inventory, or revenue account. |
You use this information to do the following:
Review information that is specific to each batch, such as status and date range
Add and make changes to transactions within a batch
Change the status of a batch
Topic | Description |
---|---|
Limitations for changing transactions | You cannot change the following information for transactions:
|
See Also:
Reviewing Journal Entries and Posting Journal Entries in the JD Edwards World General Accounting I Guide.
From Sales Order Management (G42), choose End of Day Processing
From End of Day Processing (G4213), choose Customer Sales Journal Review
You can ensure the accuracy of your sales transactions by reviewing the G/L entries that the Update Customer Sales program creates before you post them to the sales journals.
On the selected review form
Display all batches for all users and for all statuses or, to limit your search, complete one or more of the following fields:
User ID
Batch Number
Batch Date From
Batch Date Thru
Batch Status
Choose the appropriate batch job for detailed batch review.
Choose the option to review the individual document.
Field | Explanation |
---|---|
Batch Status | A user defined code (98/IC) that indicates the posting status of a batch. Valid codes are:
blank Unposted batches that are pending approval or have a status of approved. A – Approved for posting. The batch has no errors, is in balance, but has not yet been posted. D – Posted. The batch posted successfully. E – Error. The batch is in error. You must correct the batch before it can post. P – Posting. The system is posting the batch to the general ledger. The batch is unavailable until the posting process is complete. If errors occur during the post, the batch status is changed to E (error). U – In use. The batch is temporarily unavailable because someone is working with it. |
Batch Number | A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it through Next Numbers. When you change, locate, or delete a batch, you must specify the batch number. |
From Sales Order Management (G42), choose End of Day Processing
From End of Day Processing (G4213), choose Customer Sales Journal Review
If your company requires management approval before posting a batch to the general ledger, users with an authorized approval user ID can change a batch status to approved.
On the selected review form
Choose the appropriate batch.
Complete the following field:
Approved
Field | Explanation |
---|---|
App | A code that indicates whether a batch is ready for posting. Valid codes are:
A – Approved, ready for posting. P – Pending approval. The batch will not post. If the system constants do not specify manager approval, the system automatically approves batches that are not in error. |
From Sales Order Management (G42), choose End of Day Processing
From End of Day Processing (G4213), choose Customer Sales Post
After you review and approve a batch of journal entries, you can use the Post General Ledger (Pre-Post) program to edit and post each type of transaction.
This program also edits transaction batches for the Account Ledger table (F0911) and updates the batch status to allow the system to post transactions to the Account Balances table (F0902). If any errors occur during editing, the system assigns an error status to the batch and does not post it.
From Sales Order Management (G42), choose End of Day Processing
From End of Day Processing (G4213), choose Print Unposted Inventory/COGS
You can print the General Journal report to print a list of unposted batches for inventory cost of goods sold and interbranch sales. Use this information to identify and edit any batches that the system did not post due to errors.