Microsoft Dynamics NAV (Archived)

A/P Accruals

(0) Share

Report

Posted on by Linzer

495

Good Afternoon,

Can anyone share how they are handling a/p accruals?

I can't find a report to give to the accountant (invoice amounts and g/l distribution) if he wants to make any journal entries to account for invoices with a posting date in the current month but a document date in a prior month.

Thanks.

Stacey

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

RE: A/P Accruals

Hi, Seshnarayan,

... but this isn't the case :) This report is for posted entries only. "Tell me how much money do I need that I have received or sent out invoices for the current period, but actually turned up in the next period". Fair Question IMO, especially because you wouldn't have paid or received them in the current period. And it is a sub-type of A/P and A/R, obviously.

with best regards

Jens
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: A/P Accruals

Hi,

Making a entry like this is logically wrong. You are not accruing the Liability immediately after the same is received. Keeping the invoice in hand without accounting is wrong especially during the month & year end.
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report
RE: A/P Accruals

Hi Stacey,

apparently there isn't, but you can derive one with very few customizations. What you need is the amount crossing the date border for customers and vendors. Easiest would be to derive them with the "Customer Balance to Date" (Report 121) and "Vendor Balance to Date" (Report 321) ones, but others might fit, too. Your NAV partner should be able to do so easily.

I did this as an example with A/R (Report 121).

(create a copy of the report, with a new name)

Add the document date as a field that can be filtered, so the oser can enter it by hand

Alternatively, you can calculate the required filter from the reference date in OnPreDataItem:

CustLedgEntry3 - OnPreDataItem() RESET; DtldCustLedgEntry.SETCURRENTKEY("Customer No.","Posting Date","Entry Type"); DtldCustLedgEntry.SETRANGE("Customer No.",Customer."No."); DtldCustLedgEntry.SETRANGE("Posting Date",CALCDATE('<+1D>',MaxDate),31129999D); DtldCustLedgEntry.SETRANGE("Entry Type",DtldCustLedgEntry."Entry Type"::Application); IF NOT PrintUnappliedEntries THEN DtldCustLedgEntry.SETRANGE(Unapplied,FALSE); IF DtldCustLedgEntry.FIND('-') THEN REPEAT "Entry No." := DtldCustLedgEntry."Cust. Ledger Entry No."; MARK(TRUE); UNTIL DtldCustLedgEntry.NEXT = 0; SETCURRENTKEY("Customer No.",Open); SETRANGE("Customer No.",Customer."No."); SETRANGE(Open,TRUE); SETRANGE("Posting Date",0D,MaxDate); IF FIND('-') THEN REPEAT MARK(TRUE); UNTIL NEXT = 0; SETCURRENTKEY("Entry No."); SETRANGE(Open); MARKEDONLY(TRUE); SETRANGE("Date Filter",0D,MaxDate); //OS001s os.jgl SETRANGE("Document Date",CALCDATE('<+1D>',MaxDate),31129999D); //OS001e os.jgl

This would lead to the desired accrual calculation (in the picture manually entered for proof-of-concept):

The resulting report shows the accruals by customer and a total amount. The rest of the layout is still unchanged, but can be adapted easily.

with best regards

Jens
keoma 32,675 on at

Like (0)

Report

RE: A/P Accruals

try this as starting point:

msdn.microsoft.com/.../hh933599(v=nav.71).aspx