[Deanne Rasmussen]

Up

0

Down

::

Also – I believe it’s a manual upload

[Deanne Rasmussen]

Up

0

Down

::

The email is a contact at the bank.

[Deanne Rasmussen]

Up

0

Down

::

PM invoice – AP invoice – that is the originating doc number that carries over to the GL. I just need the project that was entered/selected when the PO/AP invoice is entered.

[Deanne Rasmussen]

Up

0

Down

::

that would be nice but I think this is just a one-off situation. I will put that on the table, though.

Thank you!

[Deanne Rasmussen]

Up

0

Down

::

Can you resend the script? seems to be a lot of typo’s – doesn’t work in sql

[Deanne Rasmussen]

Up

0

Down

::

this is awesome – can I get the entire script? please?

[Deanne Rasmussen]

Up

0

Down

::

The exact screen I’m referring to is: Purchasing Invoice Inquiry Zoom

You get there through the Payable Transaction Inquiry – Vendor screen by selecting the Document Number link

[Deanne Rasmussen]

Up

0

Down

::

The PA11800 and PA11801 tables are empty – what ‘process’ are you referring to? (this company is barely using all the GP functionality – project accounting is a dumping ground for tracking project costs. they don’t bill anything to customers)

[Deanne Rasmussen]

Up

0

Down

::

Thank you Kerry.

If I have a transaction from payables (receiving/invoice), I want to report the project number from project accounting. I know I was vague – sorry about that – I have all the GL transactions and originating info from payables.

[Deanne Rasmussen]

Up

0

Down

::

I want to use both receivings/invoice transactions.

[Deanne Rasmussen]

Up

0

Down

::

Accounting mgr wants to look at unposted transactions (Series Post – Batches – payable transactions) and review the Project Accounting project assigned from the AP voucher. Payables posts to the GL – not through. I’m trying to create a SmartList (probably a sql view first?) – trying to find where the project can be attached to the Account Transactions

[Deanne Rasmussen]

Up

0

Down

::

Thanks for your verification!