Reports and Generic Inquires

HiI need help to filter the customer ID for this report field to specifically only return Sales Order details for all ID’s starting with ‘N’ and ‘A’. Eg. N ALLE, A ME73Report is a standard Sales Order Details by Inventory Item used in MYOB Advanced. Screen shot attached.The field is =[SOOrder.CustomerID], so it needs to return results just for =[SOOrder.CustomerID] = ‘N’ and =[SOOrder.CustomerID] = ‘A’.Could you please advise the correct logical script to use.Thanks in advance!  

I have customized the Check Form with Remittance Report (AP641000.rpx). The report I customized has custom paper size dimensions and margins. When I go to print the report an extra blank page is being printed before the actual report. Can I know what may be the reason for this?Blank Section Printed Before Actual Report 

Is there any way that we could create user-defined fields for a branch or somewhere we can add bank information per branch? We are wanting to pull bank information for each brank onto the ar invoices. 

My company would like to send out email notifications if the cost of certain items has changed.Ideally, the notification would include a table with a format similar to the following. But I have not found a way to access the “old” cost once the value in the cost field has changed.Item Code Old Cost New Cost ABC123 $1.00 $2.00  Is there any way to report the previous field value within a notification? Thanks!

Hi,My generic inquiry won’t display the data unless I pick anything from my parameter (Customer)first, then I need to delete it when I don’t need that filter yet. Given that the date is already specified, shouldn’t it display the data as soon as I open it?I think this also causes my pivot table to not display anything.Appreciate any help!

Hi community,I saw that I can export a generic inquiry as a report and it will inherit its tables, relationships, etc. But is it possible to do vice versa? Thanks!

Hi All,I want to make a GI for Sales Order, I have tables SOOrder and SOLine, I got the fields of SOOrder to display and of SOLine not. The thing is, 1 SOOrder can have multiple SOLine details (1 SO, multiple inventory items). I think it won’t display because of that, is that correct? But how I be able to get it?Thank you in advance!

Hi All,Does anybody knows what I can put in the value to group the ‘salesperson’ and display total of its netsales above my report?Please help, thanks!

Hello,Initially, I found the Status and Customer columns narrow in width, so I just dragged the sides to stretch them. The Status content adjusted, but the customer content would not. I didn’t specify width in the GI creation, and even if I do, still no changes. Where should I make a change? Thanks!

Hi all,I am trying to make generic inquiries for the first time, but I got troubles.Can somebody please take a look at my set up?My result is, after specifying the SO Nbr and SO Type, the results grid still gives all and doesn’t filter based upon my parameter. Can someone point me to where I set it wrong? Thanks a lot! 

Is there any way to assign report versions of the same report to different companies/branches. I have seen a few workflow related solutions but wasn’t sure if there was a simpler method before going down that path. 

Is there a way I can correct / update an order after it has been invoiced? specifically for the sps edi tab for shipments. Normally I place a reference number under the SPS EDI tab for and order before it’s invoiced, however I accidentally hit prepare invoice instead of correct shipment. Now when I try to add the reference number to the order that was invoiced the “correct shipment” option is greyed out and unable to update the SPS EDI tab.

Hi There,  Can anyone help me figure out to remove an unposted GL transaction? I originally made a gl transaction for Dec 2022 that was auto-reversing in Jan 2023, before I had ‘Opened’ the Jan 2023 period. I released it and realized my mistake and the entry became ‘unposted’. I opened Jan 2023 period and made a new GL entry in it’s place. When I tried to close the December 2022 period, I got a message that I still had unposted transactions. I’m not sure how to get rid of it? I don’t want to reverse it because the reversal of the reversing entry will now ‘Post’ that Jan is open and it won’t have the initial entry to clear it out. Can anyone help me? Thanks!Vanessa

Hello,Been here multiple times with this same report, I’d like to ask how it’s possible for me to NOT display the qty and uom of an item that lists down multiple serial numbers every time SN is displayed?I originally used this Prev statement:IIf(Prev([SOShipLine.OriginalShippedQty])=[SOShipLine.OriginalShippedQty], '', [SOShipLine.OriginalShippedQty]And offourse, the result is, I’ll never get the same QTY or same UOM, though it’s another Item in the list. I do not wish that to happen, what formula can I use? I appreciate any help! Paula

Hello community,I have this existing formula where multiple serial#s per item are listed down, but the thing is, say I have 20 serial#s for that item, it lists down the name of the item, its price, and qty again and again (please take a look at the picture). In a separate concern, I received a formula in which I can make a condition that if the same description exists in the previous line, it won’t display again. But I don’t know if it’s possible and how should I insert it in my formula.Here’s my formula:=IIf(IsNull([SOShipLine.LotSerialNbr], [SOShipLine.TranDesc])<>’’, [SOShipLine.TranDesc] +'{br}'+ 'SN: ' + [SOShipLine.LotSerialNbr], [SOShipLine.TranDesc]) And here’s what I wanna add to get my desired result:IIf(Prev([SOShipLine.TranDesc])=[SOShipLine.TranDesc], '', [],[SOShipLine.TranDesc] Can somebody please analyze how this would work for me? Huge thanks! Tagging Sir @aaghaei ,this is a follow up concern sir. Could you assist further? Thanks

Hello community,I have this existing formula where multiple serial#s per item are listed down, but the thing is, say I have 20 serial#s for that item, it lists down the name of the item, its price, and qty again and again (please take a look at the picture). In a separate concern, I received a formula in which I can make a condition that if the same description exists in the previous line, it won’t display again. But I don’t know if it’s possible and how should I insert it in my formula.Here’s my formula:=IIf(IsNull([SOShipLine.LotSerialNbr], [SOShipLine.TranDesc])<>’’, [SOShipLine.TranDesc] +'{br}'+ 'SN: ' + [SOShipLine.LotSerialNbr], [SOShipLine.TranDesc]) And here’s what I wanna add:IIf(Prev([SOShipLine.TranDesc])=[SOShipLine.TranDesc], '', [],[SOShipLine.TranDesc] My desired result is to list the Item Description once with its multiple SNs. Can somebody please analyze how this would work for me? Huge thanks! Paula

can you give me advice I want to change the signatory of request payment form  and the rules must be if amount is greater or less than 100k the noted by will show and if not meet the requirements the noted by will hide. in my case I use if ([@FXFundRequestRegister] >= 100000)  but always showing not hiding help please, thank you.

This is a dumb question, but in the report writer, what table accesses the PR history tab’s data in the Purchase Receipts? The name I am given is: POReceiptPOOriginalBut this isn’t in the report writer. Is this not accessible data or am I overlooking something obvious? 

Hello,can somebody please let me know why I can’t open a report in my report designer. the name is correct. Thanks!

Hello there,Help pls. I can’t see here where this huge space after groupheader1 is coming from. I’ve tried coloring all the group to see which displays this but none of them.

Hello,I need to display the address in Shipments ([SOShipmentAddress.AddressLine1]) because I have many shipments that I’ll give different addresses under one SO (pic4). I keep getting an address that isn’t even related to the customer in the SO, then the item was redundant below (pic3). I provided my schema builder’s relationship here (pic1). (pic2) is still the address in the shipment, I haven’t made override yet so that should still be the result. Please help me get the result I want.Thank you for the help! 

Hello,Please help, I’m new to making these reports.I need to display the summary of (1) Sales Agents  (I mean despite of ARCANGEL being in the list multiple times, I need only 1 entry of his name now) in the list and their own total sales, and (2) Item Category with their total of sales too. How can I do that? I appreciate your help, thanks in advance!

Hello everyone!Can anyone please help me with this? I have multiple set of column headers. Adding another set of columns in another ‘Groupheader’ results to (1st line) COLUMN1, followed with (2nd line) DETAILS1, then (3rd line) COLUMN2, followed with (4th line) DETAILS2. I want it that COLUMN1 list down all DETAILS1 before COLUMN2 and DETAILS2 follows (just like in the picture, here, I have them in separate reports). Please help me out! Thank you! 

Hi I wanted to print VAT value as 0% when the Tax ID is not ‘VAT’ . This is the condition. But the report is not displaying ‘VAT 0%’ when the Tax ID isn’t equal to VAT.  Does anyone know how to fix this issue? Thank you.

Hi all, can somebody please kindly help me?I have to make a generation of monthly sales report. But here’s what happens, the list of those SOs are incomplete, just take a look at the total net sales and it’s too far. So I checked this first SO, and yes it has three inventory items, two of which are not listed here. I have filter for “released” but yes, three of them are all shipped and invoiced. It may be in my groupings? Could someone please kindly check my report file for me. I would appreciate any help, thanks a lot! Regards,Paula