/
Gross Sales Batch - REV170A

Gross Sales Batch - REV170A

Search the IFS Excalibur Wiki
  

 

Revenue is a batch system. We recommend that a batch be set up for each check or remittance statement received. It is wise to have a separate batch for each purchaser's check. If a check is very large, you can establish more than one batch for easier balancing by selecting a logical breaking point. If you split a check into multiple batches, be sure to set the batch status flag to `F'orce.

The Gross Sales programs allow you to enter gross sales batch and detail revenue sales data. In the Gross Sales - REV170A program, you need to enter a batch control item for balancing gross sales data. Enter the purchaser's check number, date, and amount received on each batch. If a check does not exist, do not enter the purchaser. The check number entered ties directly to Revenue checks entered in Accounts Receivable cash receipts data entry. Unless you use the `F'orce flag, the system does not permit distribution of a batch until the check is entered in the Revenue Cash Receipts - AR100E program and it agrees with component 7 (cash received) entered in gross sales data entry.

Enter the components that you want to use for balancing purposes. You can enter several components. The system verifies them against the gross sales amounts to catch many data entry errors. You control the components such as gross sales amount, cash received, or volume that are used for balancing each batch. We recommend that you always use a quantity to balance on since the system cannot validate quantity.

Each batch component value must balance to all gross sales posted to the batch before the system allows distribution to owners. Since the net value for the gross sales is a calculated figure, the amount is not stored within the system. This precludes the ability to balance the entered batch on component 6, net value. To ensure that all batches are in balance, print a batch proof report in the Batch Proof - REV772 program.

When you enter new batches, gross sales or batch components, with component amounts greater than zero, must be entered or this batch must be deleted. If you do not delete the batch, the following message displays:

YOU MUST ENTER GROSS SALES FOR THIS BATCH OR DELETE IT

If you delete all of the gross sales transactions entered for a batch, you should delete the batch as well.

After you set up the batch, enter gross sales in the data entry program that best fits your situation. You can select from the following data entry programs:

You can find more information in Gross Sales Additional Detail - REV170D.

Verifying Gross Sales Data Entry

Run the following reports to verify gross sales data entry:

For information on the use of the gross sales allocation process, refer to the Gross Sales Allocation Process - REV153 documentation.

 


Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.