How Do AAIs for Advanced Pricing Work?

 You have only two AAIs to worry about in Advanced Pricing:

• Table 4270 – Price Adjustments

• Table 4280 – Rebates Payable 

Note: Don’t be confused by the table descriptions. 

The following  rules apply, whether or not you use rebates. Just remember, unlike most Distribution AAIs (where the lower number is the Debit and the higher number, the credit), Advanced Pricing AAIs are reversed. If you think of them as you do other AAIs in Distribution, Table 4280 is the Debit and Table 4270 is the Credit.

  Now, here are three simple rules to remember for both World and Enter­priseOne:

1. If Override Price in the Adjustment Definition = Y, Table 4230 (the regular sales order revenue AAI) supplies the credit. You are telling the system that this Adjustment Definition is the price.

2. If Override Price in the Adjustment Definition = N, Table 4270 supplies the credit. You are telling the system that this Adjustment Definition is only an adjustment  to the price; typically a discount or mark-up.

3. If Override Price in the Adjustment Definition = N and Adjustment Control Code = 4 or 5, the adjustment is an accrual and does not impact unit price. Tables 4280 and 4270, respectively, supply the debit and credit.

One corollary: Remember that if you leave the G/L Class Code in the Adjustment Definition blank, Advanced Pricing AAIs (just like all others) will follow the G/L Class Code of the item.By the way, Adjustment Control Codes 4 and 5 are not just for accruals and rebates. You can do things with revenue reclassification using Adjustment Control Code 4 in connection with the 4270/4280 AAIs that your accounting folks can only dream of.

Bypassing Updating Accounts Receivable At The Time Of Sales Update

To bypass the updating of A/R, set processing option Bypass Update to Accounts Receivable to 1 in the Update tab behind Sales Update (R42800). The purpose is to restrict the system from creating a F0311/F03B11 records. F0911 records will still be created to make the journal entries balance.

The system will use the 4245 AAI for the A/R entry when bypassing updating A/R. The G/L class from the Sales Order Detail Line (F4211) will NOT be used. However, the G/L Class if set-up in the Customer Master, that G/L Class code will be used. If Customer G/L class is set to blank, then '****' is used and must be setup in the 4245 table. The F0911 record will be created at the time of sales update. When not bypassing updating A/R, the system uses the RC AAI for the A/R entry. The F0911 record is not created until the sales update IB-batch is posted.

Accounting entries at the time of Sales Update & Batch Posting

             

Setup A New UBE Job Queue

ISSUE: 

How do you setup a new UBE job queue?

SOLUTION:

To add a new UBE job queue:

On the Batch Processing Setup menu (GH9013), choose Job Queues (P986130).

1. On Work With Job Queues, click Add.

2. On the Job Queue Revisions form, complete the following fields and option, and click OK:

Host                               

• Enter the name of the server on which the queue will run.

Job Queue

• Enter the new name of the queue.

Job Queue Status

• Enter 01 if you want the queue to be active, or 02 if you want the queue to be inactive.

Queue Type   

• Define whether the queue is an EnterpriseOne queue or a non-EnterpriseOne queue. Non-EnterpriseOne queues work only on the AS/400 server.

Maximum Batch Jobs

• Define the maximum number of jobs that can run in the queue.

Port Number

• Identify the port number for the server instance on which the queue will run. 

Default Queue 

• Check the box for the default queue, or leave blank for a non-default queue.

3. OnUDC 98/JQ add the new job queue.
The setting which determines whether the job queue is single-threaded or multi-threaded is the Maximum Batch Jobs. If the Maximum Batch Jobs setting is setup as 1, only 1 active job can be running at the same time which makes it single-threaded. If the Maximum Batch Jobs setting is more than 1, then more than 1 active jobs can be running at the same time which makes it multi-threaded. 

Program ID: P986130

Application Release: 8.9x and Higher

Service Pack/Tools Release:  8.9x

Platform: ALL