Skip to Content
0
Former Member
Jun 02, 2008 at 03:06 AM

Generate Entries from AR

31 Views

Dear Experts,

Is there any standard query for generate JE entries from AR Invoice?

Since the item master cannot be chosed from balance sheet account (only income type of COA can be choose), the original entries are not recorded correctly as intended balance sheet account.

I was thinking to use a query to generate JE entries from AR invoice entries every month to adjust the figures.

For example, we base on a UDF in AR invoice to keep track of the real account number in COA. Then use a query to generate JE entries at the end of the month. It involves selection of date to list and generate a header entries and line entries.

If there is a standard query for it, that would be great!

Thanks.

Raymond