Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 9 matches

by christina
25 Mar 2019, 13:35
Forum: Sage 50 Report Designer
Topic: BOM Issue
Replies: 3
Views: 3880

Re: BOM Issue

Hi Bruce. I have attached 2 sage reports Sage Report 1 - This report doesn't pull through the stock code (for the product that has BOM attached) Sage Report 2 - This report does pull through the stock code (but it pulls it through twice) this is only affecting products that have BOM attached to them...
by christina
21 Mar 2019, 13:57
Forum: Sage 50 Report Designer
Topic: BOM Issue
Replies: 3
Views: 3880

BOM Issue

Hi I have a product that has BOM on it when it pulls through to 1 of my reports its pulling through a duplicate line of the same item. On the order number Header, the filter I'm using is STOCK.HAS_NO_COMPONENT = 0 AND STOCK.HAS_BOM = "" which is working as if I remove it I get a duplicate ...
by christina
04 Jan 2019, 23:26
Forum: Sage 50 Report Designer
Topic: Expression Editor (Replace)
Replies: 1
Views: 3155

Expression Editor (Replace)

Hi All Wondering if someone can help, I am trying to use the replace function in the expression editor. I have all the replace data correct but I'm not 100% sure how to format the expression. Currently, the expression is SALES_ORDER.NOTES_3 = "" ? SALES_LEDGER.COUNTRY_CODE : SALES_ORDER.NO...
by christina
07 Apr 2018, 15:53
Forum: Sage 50 Report Designer
Topic: Compnent Code Duplicating
Replies: 2
Views: 3162

Re: Compnent Code Duplicating

Hi Bruce

I figured out the issue I had to add an extra filter onto the details section.

Thank you for all your help
by christina
06 Apr 2018, 19:48
Forum: Sage 50 Report Designer
Topic: Compnent Code Duplicating
Replies: 2
Views: 3162

Compnent Code Duplicating

Hi I have a report I have pretty much got in all working apart from one product keeps pulling as a duplicate and I'm not sure why it is part of a BOM all other BOM on different products pull through without them being duplicates. I have 2 sections Header and Details The Header Filter is: STOCK.HAS_N...
by christina
06 Apr 2018, 13:01
Forum: Sage 50 Report Designer
Topic: Sage 50 Report Designer Help
Replies: 6
Views: 4982

Re: Sage 50 Report Designer Help

Hi Bruce

That worked thank you so much.

Christina
by christina
05 Apr 2018, 21:52
Forum: Sage 50 Report Designer
Topic: Sage 50 Report Designer Help
Replies: 6
Views: 4982

Re: Sage 50 Report Designer Help

Hi Bruce Thank you for this, this does work so all the spaces no longer pull through but I'm wondering if you can put 2 replace strings in the same variable. I have tried it a few ways and can't seem to get it working but not sure if Im inputting it incorrectly. Please see below what im trying to do...
by christina
20 Mar 2018, 13:28
Forum: Sage 50 Report Designer
Topic: BOM
Replies: 1
Views: 2553

BOM

Hi I need to find a way to show the bill of materials in a report so it shows the child items not the parent items I have the below but then it shows anything without a BOM as 0 quantity and is also showing only 1 item on the BOM and not the 2 as it should be. STOCK.HAS_NO_COMPONENT = 1 ? INVOICE_IT...
by christina
16 Feb 2018, 22:15
Forum: Sage 50 Report Designer
Topic: Sage 50 Report Designer Help
Replies: 6
Views: 4982

Sage 50 Report Designer Help

Hi All, Wondering if someone can help. I have finished of most of my Sage report but I'm struggling with 2 statements (Any help would be amazing) 1st Statement Issue: So far I have INVOICE.DEL_NAME LIKE "" ? INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 which is working fine but I also need to ...