MxLoader

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.
------------------------------

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Well just an update, ..updates occur to INVOICE etc. if I leave the INVOICECOST. columns empty, unfortunately I want to update the GLDEBITACCT in the invoicecost table. 
MX_INVOICE

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Adam,
I recreated as I have tried so many iterations. I run the query and it pulls data from all the tables except INVOICECOST. All I need to do is update the GLDEBITACCT on existing invoices as well as PO's (works) and receipts. 
Thanks

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Hi Wes, 
I moved the invoice line columns ahead of the invoice cost columns and it worked as expected. I attached my very abbreviated template. I did the same with your template and it worked too. Let me know if you have any issues.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.
------------------------------

Original Message:
Sent: 04-21-2022 07:44
From: Wes Williams
Subject: MXINVOICE

Adam,
I recreated as I have tried so many iterations. I run the query and it pulls data from all the tables except INVOICECOST. All I need to do is update the GLDEBITACCT on existing invoices as well as PO's (works) and receipts. 
Thanks

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Thanks Adam!
I got it working! Any pointer on receipts? I also need to update the GLDEBITACCT there.

-Wes

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Original Message:
Sent: 04-21-2022 08:21
From: Adam Ames
Subject: MXINVOICE

Hi Wes, 
I moved the invoice line columns ahead of the invoice cost columns and it worked as expected. I attached my very abbreviated template. I did the same with your template and it worked too. Let me know if you have any issues.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-21-2022 07:44
From: Wes Williams
Subject: MXINVOICE

Adam,
I recreated as I have tried so many iterations. I run the query and it pulls data from all the tables except INVOICECOST. All I need to do is update the GLDEBITACCT on existing invoices as well as PO's (works) and receipts. 
Thanks

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

I have receipts working as well

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Original Message:
Sent: 04-21-2022 10:30
From: Wes Williams
Subject: MXINVOICE

Thanks Adam!
I got it working! Any pointer on receipts? I also need to update the GLDEBITACCT there.

-Wes

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-21-2022 08:21
From: Adam Ames
Subject: MXINVOICE

Hi Wes, 
I moved the invoice line columns ahead of the invoice cost columns and it worked as expected. I attached my very abbreviated template. I did the same with your template and it worked too. Let me know if you have any issues.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-21-2022 07:44
From: Wes Williams
Subject: MXINVOICE

Adam,
I recreated as I have tried so many iterations. I run the query and it pulls data from all the tables except INVOICECOST. All I need to do is update the GLDEBITACCT on existing invoices as well as PO's (works) and receipts. 
Thanks

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------

Hi Wes, 
Great to hear!!!

------------------------------
Adam Ames
Kwik Trip, Inc.
------------------------------

Original Message:
Sent: 04-21-2022 13:31
From: Wes Williams
Subject: MXINVOICE

I have receipts working as well

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-21-2022 10:30
From: Wes Williams
Subject: MXINVOICE

Thanks Adam!
I got it working! Any pointer on receipts? I also need to update the GLDEBITACCT there.

-Wes

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-21-2022 08:21
From: Adam Ames
Subject: MXINVOICE

Hi Wes, 
I moved the invoice line columns ahead of the invoice cost columns and it worked as expected. I attached my very abbreviated template. I did the same with your template and it worked too. Let me know if you have any issues.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-21-2022 07:44
From: Wes Williams
Subject: MXINVOICE

Adam,
I recreated as I have tried so many iterations. I run the query and it pulls data from all the tables except INVOICECOST. All I need to do is update the GLDEBITACCT on existing invoices as well as PO's (works) and receipts. 
Thanks

------------------------------
Wes Williams
Northrop Grumman

Original Message:
Sent: 04-20-2022 08:29
From: Adam Ames
Subject: MXINVOICE

Hi Wes,
Can you attach your MxLoader sheet? Just need the two header lines as no data is necessary.

Thank you,
Adam

------------------------------
Adam Ames
Kwik Trip, Inc.

Original Message:
Sent: 04-18-2022 13:17
From: Wes Williams
Subject: MXINVOICE

I am attempting to use the MxLoader to update the GLdebitacct for a number of invoices. The Loader Result is a green OK, but nothing is changed, I have tried add/change and change. Anyone have any pointers? The MXPO allows the change, but no luck with MXRECEIPT and MXINVOICE.

Thanks
-W

------------------------------
Wes Williams
Northrop Grumman
------------------------------