unexpected payment

Hi,

can anybody help me, where I should start to search. Soemtimes when posting an Invoice with payment term ‘by card’, payment method empty, Navision is generating a payment. Although there is no Bal. Account No. in the G/L Entry, or customer ledger entry. Also the tab with bill-to customer datas is correct.

Mike

Interesting.

We actually had someone with a similar problem, and there was quite a long thread on www.mbsonline.org about it. I think in the end it was either a set up or customizations issue.

The thread is here… http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=16385

Hi, Mike
did you check whether in the Payment Method there is a Bal. Account No. set? That would explain the mystery.

Hi Anna,

the field payment method ist empty in the invoice header. When posting, Navision ‘takes’ the method cash, where a Bal. Account No. is set. But this method is not set to the customer, too.

Mike

did you read the thread on mbsonline that I linked to above [*-)]

Paul Croucher
Member

Status: offline

Posted - 2006 Feb 02 : 04:41:27 Show ProfileClick to see Paul Croucher's MSN Messenger addressAdd Paul Croucher to Buddylist
I have a strange situation here where on 1 Customer only, if an order is Invoiced a Payment for the invoice amount is automatically generated. I copied the Customer definitioned and put it into a Test environment and raised an order and shipped and Invoiced it and no payment was generated. Is there something different in Version 4.0 that would allow the automatic generation of a payment when posting the invoice. Thanks…Paul


Paul Croucher
Navision Consultant For Sci-Net Ltd

Country: United Kingdom ~ Posts: 100 ~ Member Since: 2005 Oct 25 ~ Last Visit: 2006 May 30 Alert Moderator

Steven Weaver
Moderator

Status: offline

Posted - 2006 Feb 02 : 04:50:44 Show ProfileSend Steven Weaver an AOL messageAdd Steven Weaver to Buddylist
Hi Paul

It has always been around Look at the Payment Method Code associated with the customer, if it has a balancing account specified Navision will generate the payment along with the invoice.


Steven Weaver

MVP - Microsoft Business Solutions Navision

Country: United Kingdom ~ Posts: 1933 ~ Member Since: 2000 Nov 03 ~ Last Visit: 2006 Jun 05 Alert Moderator Go To Top Of Page

Paul Croucher
Member

Status: offline

Posted - 2006 Feb 02 : 05:22:10 Show ProfileClick to see Paul Croucher's MSN Messenger addressAdd Paul Croucher to Buddylist
Hi Steve, you are right and I was aware of the balance on Payment Method Codes but this Customer doesnt have one specified however they used to and am wondering if; although it has been removed, the Customer card still thinks it is present. I will zoom in on the table and have a look. From one So’ton person to another Thanks for the help.


Paul Croucher
Navision Consultant For Sci-Net Ltd

Country: United Kingdom ~ Posts: 100 ~ Member Since: 2005 Oct 25 ~ Last Visit: 2006 May 30 Alert Moderator Go To Top Of Page

Steven Weaver
Moderator

Status: offline

Posted - 2006 Feb 02 : 05:58:54 Show ProfileSend Steven Weaver an AOL messageAdd Steven Weaver to Buddylist
Hi Paul

No problem. On another slight difference if you put on a new order and process it does it do it then? Just wondering if it was an old order prior to the payment method change.

Have fun!

Steve


Steven Weaver

MVP - Microsoft Business Solutions Navision

Country: United Kingdom ~ Posts: 1933 ~ Member Since: 2000 Nov 03 ~ Last Visit: 2006 Jun 05 Alert Moderator Go To Top Of Page

Paul Croucher
Member

Status: offline

Posted - 2006 Feb 02 : 06:19:55 Show ProfileClick to see Paul Croucher's MSN Messenger addressAdd Paul Croucher to Buddylist
Hi Steve, good thinking but these are new orders. I zoomed in on the Customer Card and the Payment Method was blank. It obviously thinks its still there so what I have done is removed the balancing Bank Account from the Payment Method as it is nolonger used. Have informed the accounts people and will wait and see what it does next time.


Paul Croucher
Navision Consultant For Sci-Net Ltd

Country: United Kingdom ~ Posts: 100 ~ Member Since: 2005 Oct 25 ~ Last Visit: 2006 May 30 Alert Moderator Go To Top Of Page

Steven Weaver
Moderator

Status: offline

Posted - 2006 Feb 02 : 09:09:49 Show ProfileSend Steven Weaver an AOL messageAdd Steven Weaver to Buddylist
Hi Paul

My suggestion after this then is that there is a modification hiding somewhere!! Oh well lets see how they get on with your change.


Steven Weaver

MVP - Microsoft Business Solutions Navision

Country: United Kingdom ~ Posts: 1933 ~ Member Since: 2000 Nov 03 ~ Last Visit: 2006 Jun 05 Alert Moderator Go To Top Of Page

Looks like you have a customization of some sort which forces the method “cash” when the method is left blank on the Order Header card.