Can it be set that the GL date is the Sale Order date or
Ship to Date?

Answer Posted / tgs100

Yes. In Transaction source, there is a field called "Derive Date". If we select this value as YES and if there is no GL date value in interface table (GL date will be blank for ORDER ENTRY source), then auto invoice program uses Ship to date and then Sale Order date. If both these dates are in closed period, then GL date mentioned in Auto invoice parameter will be used.

Note: If "Derive date" field is set to NO and if GL date is null in interface table, then GL date given in Auto Invoice parameter will be used.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1565


How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.

2070


Explain about Localization (IND & US ) in Oracle Apps ?

2709


How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2317


How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12

6565






How do you adjust receivables?

1770


What is Difference between Auto Copy Journal and recurring journal?

1302


Re: what are the Issue that we face in Gl,PO and AP while Supporting

1846


Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1265


what is the meaning of purchase default and what are the types

1680


What are the inventory report to check inventory status.

2011


When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

2466


How to do the analysis of discounts lost and fixing the root cause?

645


What is the db number of a particular customer TCA?

932


Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?

1598