How do you assign a ledger account to a Counting Journal

(0) Share

Report

Posted on by Mel Walker

Hey!

We have been using counting journals (Inventory & warehouse mgmt> Journals> Item counting> Counting) for the purpose of stock/ item counts, however I just realised it is not offsetting the movements to a ledger account.

I checked the set up, however was unable to select a default offset account, as it has been greyed out. (Setup> Journals> Journal names, inventory)

Is it possible to assign an offset account to a counting journal? If so HOW?

Thanks in advance

Mel

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Weaveriski 23,618 Moderator on at

Like (0)

Report

No it is not possible, it impacts the inventory asset account and then the profit/loss account from the posting setup. It will always post to the offset account of profit/loss so I am not sure why you believe there is no ledger offset - it cannot post a one-sided journal to the inventory asset account only.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Melissa,

As Steve says, it will use the accounts defined on the 'Stock' fast tab of the Item's Item group. It is not possible to manually define an offset account on a Count Journal (like you can do on a Movement journal).

The only time I see that a Count adjustment would not post to the ledger is if AX thought the item(s) that were being adjusted have no cost price.

Go to the Count Journal Lines for a posted count journal. Pick a line which has an adjustment (the 'Quantity' column is not blank). Click Inventory -> Transactions. On the Inventory transactions form, click Ledger -> Financial voucher. Here, you see the postings made.

Was this reply helpful? Yes No
Mel Walker 92 on at

Like (0)

Report

Thank you Guy & Steven, we had actually set up a ledger account just for profit & loss. So we will have to tweak our reporting based on this.

Mel

Was this reply helpful? Yes No
Hector Cazot on at

Like (0)

Report

I made a small scenario, I have invoiced the purchase order for a material. Then I made a counting journal, if the counted quantity is less than the original, both physical and financial vouchers shows what I expect to see, but if the counted quantity is more no voucher is made... I'm using weighted average to date item model group for the items.

What could be the reason that when entering a counted quantity there is no voucher posted?

Was this reply helpful? Yes No