mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 1:39 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Strict Next Sales invoice
PostPosted: Sun May 13, 2012 11:49 am 
Offline

Joined: Sun Mar 21, 2010 7:52 am
Posts: 204
Country: United Arab Emirates (ae)
Dear Experts,

We are also dealing with whole sale business and we are generating invoices to customers from Sales & Marketing Module of Navision.

I have a scenario like

If the customer has not paid the payment for the last invoice we should not be able to generate new invoice.

can we strict it that way while generating invoice.

for example we generated an invoice to the customer ABC worth of 400 Dirhams with invoice number PSI-0001.

Now the user is going to generate a new invoice which would be invoice number PSI-0002. or any other number.

If the customer has not payed for PSI-0001, system should stop and give message that "LAST INVOICE HAS NOT YET PAYED FOR THIS CUSTOMER"

Kindly advice if that is possible, IF possible then where and how can i restrict this.

I know by default the system gives warning of the overdue balance, but in this case system should not let us make a new invoice unless the payment for last invoice is payed.

Thanks!


Top
 Profile E-mail  
 
 Post subject: Re: Strict Next Sales invoice
PostPosted: Sun May 13, 2012 1:36 pm 
Offline

Joined: Mon May 18, 2009 6:36 am
Posts: 792
Location: India
Country: India (in)
Check that the customer should not have any open invoice while creating every new invoice. Put this code when you release invoice.
Make sure that you have been applying each payment to corresponding invoice while doing payment entry.
Code: Select all
CustLedgerEntry.SETCURRENTKEY("Customer No.",Open);
CustLedgerEntry.SETRANGE("Customer No.","Customer No.");
CustLedgerEntry.SETRANGE(Open,TRUE);
CustLedgerEntry.SETRANGE("Document Type",CustLedgerEntry."Document Type"::INVOICE);
IF CustLedgerEntry.FINDFIRST THEN
   ERROR('LAST INVOICE HAS NOT YET PAYED FOR THIS CUSTOMER');

_________________
Vijay Gupta
Changing the code is last step. Try to change processes first...


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: