Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Where is "Chopper" when you need him?


harryglos

Recommended Posts

Statement trouble H-E-L-P

 

I can’t seem to get Statements working properly. If I call up a customer statement one at a time by their Id number everything works fine, it shows all their open (Invoiced) orders and the total of all invoices. However, if I try to pull up all the Statements at once, so I can print them at the same time, it doesn't work work. The total of all invoices shown in the Sub Summary field is correct. But only one (1) Invoice number is shown in the body of the Statement. So if five invoices comprise the total, only one Invoice number shows. Here is my layout and script.

 

Header: Customer name, address and CustId

Body: InvoiceNbr, InvoiceDate, BalanceDue

Sub Summary: BalanceDueSum

 

I FIND all orders from the Status field marked “Invoiced”

Sort order: CustId, InvoiceDate, InvoiceNbr

 

I only made this topic out with Choper's name because he's a great lurker...

 

Thanks for your help,

 

Harry

Link to comment
Share on other sites

Originally posted by HarryGlos:

[qb]Statement trouble H-E-L-P

 

I can’t seem to get Statements working properly. If I call up a customer statement one at a time by their Id number everything works fine, it shows all their open (Invoiced) orders and the total of all invoices. However, if I try to pull up all the Statements at once, so I can print them at the same time, it doesn't work work. The total of all invoices shown in the Sub Summary field is correct. But only one (1) Invoice number is shown in the body of the Statement. So if five invoices comprise the total, only one Invoice number shows. Here is my layout and script.

 

Header: Customer name, address and CustId

Body: InvoiceNbr, InvoiceDate, BalanceDue

Sub Summary: BalanceDueSum

 

I FIND all orders from the Status field marked “Invoiced”

Sort order: CustId, InvoiceDate, InvoiceNbr

 

I only made this topic out with Choper's name because he's a great lurker...

 

Thanks for your help,

 

Harry[/qb]

You should have a subsummary layout

Header = Logo info and "Invoice Statement"

 

SubSummary Sorted by Customer Name (breakPage after each customer)

 

Inside the SubSummary

Place these fields

Inv Date, Invoice Number, Days Old, Amount, Total Invoice.

 

Grand Summary (trailing)

Total Current, Over 30 , Over 60 , Over 90, Grand Total Due

 

Use your customer list to find the open invoices

 

I.E. Script for Customer List

 

Set Error Cature [On]

Show All

Go to record request [first]

Loop

Copy Cutomer ID

Perform Script (External) (Invoices:: Find Open Invoice)

Go to Record Request [Next} [Exit after last]

End Loop

 

Script for Invoices=

 

Find Open Invoice

 

Set Error Capture [On]

Enter Find Mode [ ]

Paste (Cust ID)

Set Field (Status field) [invoiced]

Insert Text >0 (Balance)

Perform Find [ ]

If Status(CurrentError) Not = 401

Go to Layout SubSummary

Enter Preview Mode

Print [No Dialog]

Enter Browse Mode[ ]

Go to layout (Orignal)

Else

End If

 

I think this will solve your problem

 

P.S. Thanks for the Plug in your title of the post.

Although I am not quite sure what you maen by "Lurker"

Link to comment
Share on other sites

Lurker, aka... Helper, Guy who's around, Man amoung men, Peoples Friend and in general one heck of a human being.

 

Lurker, a good thing and I and we appreciate you!

 

Harry

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

Terms of Use