Sunday, February 28, 2010

How Autoinvoice Derive Dates

General ledger date for Invoices without Rules :
1.Autoinvoice uses the general ledger date in the interface tables, if one exists and it is in an open or future enterable period.
2.If a general ledger date is not populated in the interface tables and Derive Date is set to no, Autoinvoice uses the value of the default date parameter entered for the particular Autoinvoice run.
3.If a general ledger date is not populated in the interface tables and Derive Date is set to yes, Autoinvoice uses the ship date in the interface tables. If the ship date does not exist or is in a closed period Autoinvoice uses the sales order date. If the sales order date does not exist or is in a closed period, Autoinvoice uses the value of the default date parameter entered for the particular Autoinvoice run.

General ledger date for Invoices with Rules
1.Autoinvoice uses the general ledger date in the interface table, if one exists and it is in an open or future enterable period.
2.If the invoice uses Bill in Advance as the invoicing rule, Autoinvoice uses the earliest accounting rule start date as the invoice Gl date.
3.If the invoice uses Bill in Arrears as the invoicing rule, and the invoice line has an accounting rule of type ’Accounting, Fixed Duration,’ and a period of ’Specific Date,’ Autoinvoice computes an ending date using the latest accounting rule date. The latest ending date is the GL date. For all other accounting rules, with Bill in Arrears as the invoicing rule Autoinvoice computes an ending date for each invoice line based on the accounting rule, accounting rule start date, and duration. Once Autoinvoice computes the ending date for each line of your transaction, it takes the latest ending date and uses it as the invoice GL date. Rule Start Date
If the invoice does not use an accounting rule with a type of ’Accounting, Fixed Duration’ and a period of ’Specific Date,’ or if Derive Date is not selected, Autoinvoice uses the default date parameter entered for the particular Autoinvoice run.
If the invoice has an accounting rule with a type of ’Accounting, Fixed Duration’ and a period of ’Specific date,’ Autoinvoice uses the earliest accounting rule date as the rule start date. For example, if the accounting rule dates are 10–JUN–02, 10–JUL–02 and 10–AUG–02,
Autoinvoice uses 10–JUN–02 as the rule start date. If it is elected to derive the date, Autoinvoice first uses the ship date in the interface table. If the ship date does not exist, Autoinvoice uses the sales order date. If the sales order date does not exist, Autoinvoice uses the default date parameter entered for the particular Autoinvoice run.

Transaction date
If a transaction date is not passed for an invoice or debit memo, Autoinvoice uses the general ledger date. If the transaction date is passed specifically, it will be used.

1 Responses to “How Autoinvoice Derive Dates”

Jamdocz said...
February 8, 2013 at 8:08 AM

Thanks, it helped me out.


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.