User_Q6VSA Newbie

Hey Patrick, Resolved it by removing the formulas for the elements (item receipt, bill, journal and ownership transfer), and replaced them with debit and credit amounts. with the bills, it was pulling through the line info component entries, but referencing the header info. The figures were all wrong, now they're not. Now…

Thanks Patrick, That search is useful, but we've got that covered in other searches. I summed up the totals in the workbook. Item receipt, ownership transfer, bill credits and journals all tally with the saved search GRNI results which mirror the GL, but bills are right off. I'm going to have to go through it and work out…

Journal entries have been done manually, and now via Post Bill variance. Journal entries are pulled out of the GRNI account using the formula detailed third from top. No, the main issue is some bills appearing anywhere from 4 to 12 times in the dataset results.

I already have Patrick. The criteria are the account is the GRNI account, and posting is true.

Am working on a criteria formula that includes type is bill and only bring up main line, but it's proving elusive to find one that works

Thank you Patrick. That's almost identical to another saved search I put in place earlier which picks up on the purchase order items received not billed, along with accrued value. The issue is trying to put something together in one search or workbook that picks up on the PO's, item receipts and ownership transfers the…

Transaction Accounting Line: Account is GRNI account Posting is true I'm trying to replicate and expand on the SuiteAnswers 65324 workaround for a GRNI report/saved search. Those criteria worked well for that, and the formulas below worked fine in the results. My thinking is to get similar type output in Analytics and then…

Thank you. Yes, the bill amounts are mentioned as follows: 1) In the header as a total amount. 2) In the line items as a total and broken down by item, quantity and rate. 3) In File communications as PDF's. Those are the only instances I can find, and in the case of this particular bill, it's coming up in the dataset three…

Hi Patrick, Thank you. Yes, it's a transaction dataset. I have tried using Main Line True earlier, but it removed the bills from the dataset completely. Going Main Line False removes Item Receipt/Journals/Ownership Transfer, so I have to leave them all in. Regards,

Thanks Ivy, An amended version of that line worked.. case when {type#display} = 'Bill' then {foreigntotal} else 0 end