Skip to Content
0
Former Member
Mar 18, 2009 at 01:58 PM

Query - A/P Invoice

619 Views

Hi all experts.

I wonder if you could help me create a query. The information I'm looking for is contained in the A/P Invoices and also involves profit centres and accounts.

We have a case where our client has made transactions containing profit centre on the rows of the A/P Invoice u2013 and this used to be attached in the journal entry (In SAP B1 2005A at least). In SAP B1 2007A it seems that GL accounts defined as type u201COtheru201D doesnu2019t support the use of profit centre. The account type needs to be of type u201CIncomeu201D or u201CCostu201D to be able to maintain the profit centre in the journal entry. We have now changed this, but have some transactions from February and March that we need to change (update) the profit centre on. The plan is to do this through some bookkeeping, but for that I need the amounts to use.

So here is the query I would require for this task:

I would like to list all instances of A/P Invoices and their corresponding (from rows table) account code (user select the account code) and also their corresponding profit centre - for a given period of time (selected by user, date between dateA and dateB). It would also be essential to have the amount summarized for each profit centre and a total amount for the account.

Anyone care to give it a try?

Appreciate all help I can get on this case.

Thanks and regards, Runar Wigestrand.

Edited by: Runar Wigestrand on Mar 18, 2009 2:58 PM