SageForum for UK versions of Sage 50- Help and support.

Hi Bruce,

Will defintely have a look at your back ordering syst as it sounds ideal.

Thanks
Gareth

Morning Bruce, Will attempt to have a go with data joins myself but want to know if poss before I attempt! Background We dont use any sort of stock control system...so Purchase orders raised arent posted to the ledger. Purchase Order module just used as dashboard control etc using custom fields as d...

Hi Bruce,

Apologies im late getting back to you been shortstaffed so all project stuff on back burner.

This work relly well now from your recommendation so thanks again.

Cheers
Gareth

Hi Bruce, Yeah I do plan on doing a seperate sage report showing products to pivot from. But do want to keep this report as is on an invocie basis so can include the transport costs per invoice...when we book transport jobs we reference the sales order no. so do a lookup on this. Right im with you s...

Morning Bruce, Just to establish if the invoice is a Roofing customer or not, anything else we just call a GRP customer...which is vey broad but we dont really get much more detaled than that. Reasons Currently so can put the market type in salesledger analysis 1. And then from that distinguish the ...

Hi, Ignoring if SALES_LEDGER.ANALYSIS_1="" for the time being. If the last invoice item is none Roofing (no barcode R) it returns GRP even if any other items are roofing with the R in background. e.g. Roofing then none roofing prod example.JPG So the above should return roofing but for som...

Hi Bruce, Yeah that works great.. but is there a way to accomodate it with the If market is blank only hen allocate market type. At moment.... Trim(cstring(STOCK.BARCODE)) ="R"?"ROOFING":"GRP" Overides what market type is in background. Not really a biggie for new custo...

H Bruce,

Appreciate your time there!

Yeah I thought maybe a space before R but quadruple checked (dont know the trim function) and checked was the R in barcode.

Tried dont if formula a but diff and didnt work.

Cheers for this big time saver

Good morning Bruce, Ive tried it first thing this morning and unfortunately Im struggling getting it to return correct market type. Keeps returning GRP even on a test invoice with a single roofing product on. Returns GRP as well if customer doesnt have a market type and inv for said customer doesnt ...

Hi Bruce, I have identifiers in customer analysis 1, either ROOFING or GRP. To show customer type in invoice profit reports. I run a profit report containing this above field and then pivot/filter on customer type. When the field is blank (where we havent set the customer type in new customer screen...

Hi Bruce,

Is there a way to add an invoice count for each day underneath the last invoice for that day.... and a total bal amount at the last invoice date for each day.

If theres not a way or too much work doesnt matter as it stands is perfect.

Thanks
Gareth

Absolutely magical!... :D :D Thanks Bruce and for the quick reply. Yeah I didnt think about the odd part payment etc. Have a customer we build a high volume of roofing kits for and they seem to find it real difficult matching our invoices to there statement. Is high volume to be fair...but I know if...

Good afternoon, Is there a way of linking invoice fields in the background so alongside our Inv no. we have customers: Purchase Order number 1st line of delivery address eg customers name. We are sending on behlaf of our customer to his customer. So needs to be invoices delivery 1st line. Delivery a...

Hi Bruce, yes sorry wasnt very clear. Your template works great but I want some exceptions to the IF statement please if possible. So if possible in the construction of an IF statement keep it as it is but exclude certain scenarios. Current IF Statement INVOICE_ITEM.QUANTITY="EA"?0:INVOICE...

Amended layout below:
Errors when ran, number of errors doesnt match error lines: