Pastel Partner: Supplier Invoice on a project

Question

Hi 
 We captured some supplier invoices to a specific project, let's call it ABC 
 When we print an ABC project report the supplier invoice is reflecting. 
 However, when we process an Income Statement in the BI Report module - we see the supplier invoice - but the Project code column is blank on the Transactions tab (when you unhide the Transactions tab and find your supplier invoice transaction) 
 So at project level the supplier invoice has pulled through, but not on transaction level. 
 However, when we process cashbook entries we can see the payment on the project report against project ABC , and we see it in the Transactions tab of the BI report reflecting against project ABC 
 Question is - why won't the supplier invoice project code show up on the Transactions tab in the BI report?

Jan.Prins · Accepted Answer

Hello shellsg Thank you for posting your query. When you process a supplier invoice, and allocate a project to the invoice, that project is allocated to the supplier account you selected. The same will happen to the supplier accounts you select on the cashbook. When you select a general ledger account on the cashbook, the project is allocated to the account selected on the cashbook. When you run the management pack, it only looks at general ledger accounts, and not customer or supplier accounts. The balance for customers and suppliers is stored in the supplier control account and customer control accounts and calculated accordingly. So when you run the management pack, you will not see projects for the customer or supplier transactions, but only for the ledger transactions. 
 Let me know if the suggested answer has helped, by clicking on Verify answer 
 Jan

Sage 50cloud Pastel

Pastel Partner: Supplier Invoice on a project

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING