PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

Posted By Sammylie over 4 years ago

Hello All,

Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.

I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which i used the GACCENTRYD TABLE. I notice the GACCENTRYD.DES field is not picking the Payment description instead its picking the Journal default Description on the header.

Please is try a query i can use to update the GACCENTRYD TABLE WITH PAYMENTH.?

PLEASE FIND SCREENSHOT BELOW.

Thanks

Top Replies

Rafael over 4 years ago in reply to Sammylie +1

You can technically update the data description with a SQL script, however moving forward you would want to update the PRINC auto journal to pull the desired descriptions into GACCENTRYD when a payment…

0 AH3 over 4 years ago

You will have to look at the auto journal lines. That's what tells the system what to pass to which field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sammylie over 4 years ago in reply to AH3

Hi AH3,

Thanks a lot, but what i want is to update it with sql because i have created a lot of payment which the description is not updating.

So i believe from SQL will can update it.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rafael over 4 years ago in reply to Sammylie

You can technically update the data description with a SQL script, however moving forward you would want to update the PRINC auto journal to pull the desired descriptions into GACCENTRYD when a payment is posted.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sammylie over 4 years ago in reply to Rafael

Hi Rafael,

Thanks a lot.

Please can you give me the SQL Script to update the description?

I will really appreciate it.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 GMT over 2 years ago in reply to Sammylie

Hi Sammy,

Did you get the SQL script as requested?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sammylie over 2 years ago in reply to GMT

No, Rafael didn't send it to me.. I still need it , if you have kindly send to me.

Thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING