Quick question which report do I print to pass my COGS accrual entry to account for the Adagio Invoice Item Charges.

In the future could we have a COGS a/c field on the Adagio Items
In the Company Profile System Option a Default ((Adagio Item Accrual A/c))

Allowing for the creation of a a Default update batch to the Ledger DB COGS and CR Adagio Items Accrual - Enabled once the company is using Adagio Items.

The corresponding entries from Payables would be coded to that clear that account
Any un-charged items would easily be identified.

Hi Edward

Not only does this not read like a quick question, but the answer is anything but simple.

There is a cost field for Adagio Invoice items, but it is for informational purposes only.

There is no specific report that passes Adagio Invoices item cost information to the GL from Adagio Invoices. You will have to create one using GridView or Crystal Reports (GridView is a better option). If you create it with the proper layout, it can then be used as a starting point for importing the entry into a GL batch.

If as you suggest the corresponding entries from Payables would be coded to clear the credit side of the accrual entry, that is going to open up a whole can of worms, because it is almost certain that you will have a major reconciliation job each month when the clearing account does not have a zero balance.

Good luck

Steve

A better solution would be to implement Adagio Inventory, which will work with Adagio Invoices.

To Douglas and Steve,

Douglas sorry you did not see where the thread was coming from, I actually have implemented Adagio Inventory. The problem is that there are charges which must be invoiced on the fly and accounted for as COGS.
If while invoicing I had the option to input an Adagio Inventory Items Cost Price then I would get creative with Category and Inventory Control Accounts for ((Non Inventory Items)).


I agree with you Steve however if I was given the ability to associate separate accrual accounts for each Adagio Item created then reconciliation would be a breeze.

I have actually created such a report for the Adagio Invoices however I am having a difficulty in finding the field to (Filter)) for Adagio Invoice Items only, can you can throw me a life line. grid-view.


Regards

Hi,

If you are invoicing items using IN with Inventory, you can import the invoiced items (from IN) as shipments into Inventory.

When you post the shipments in IC, you will be able to push the offsetting debit to a Cost of Sales account.

As Steve has suggested, this isn't necessarily a trivial task and may take some expertise from your Adagio Consultant to get the proper fit.

Call your dealer or/we could assist 800-540-3164.

Brian