User_FZNHI

Sorry - did not realise this response came in. Can i email you the file directly at all? Sales order was for 57,000 Billing Schedule is evenly over 12 months - which is 4,750 But the individual line qty were:- and when the RMA was created, 7 months in - it used more than 5 decimal places... and this did NOT agree to…

in When we select Authorise Return on Sales Order - how can we ensure it equals the amount previously i Comment by User_FZNHI Oct 7, 2020 5:39PM

Transaction search:- Output last two columns... Thanks for your fast response Cheers LIsa

in Case Formula - ERROR: Invalid Expression? What am I doing wrong? Comment by User_FZNHI Sep 24, 2020 4:45PM

We use RF Smart for our counts and with the handheld devices it is somewhat faster. Before we had RF Smart - we did inventory worksheets - it worked out fine as the accountants took the count information - worked out the variances to ensure they were reasonable before it was uploaded. This is more complicated if you have…

in inventory count Comment by User_FZNHI Sep 24, 2020 4:38PM

Sorry just noticed the screen shot did not post...

in We are having discrepancies with our COGS account in the income statement vs the "Est. Extended Cost Comment by User_FZNHI Sep 24, 2020 4:15PM

Unfortunately i am having no luck... I added Applying Transaction: Type to see if that would make a difference. It didn't case when {applyingtransaction.type} = 'item fulfillment' then {applyingtransaction.number} ELSE NULL END case when {applyingtransaction.type} = 'invoice' then {applyingtransaction.number} ELSE NULL END…

in We are having discrepancies with our COGS account in the income statement vs the "Est. Extended Cost Comment by User_FZNHI Sep 24, 2020 4:05PM

Will this deal with two fulfillments and two invoices on the same sales order. The problem is i want a financial report that shows me profitability by customer - and that is at the invoice level. the field "Est. Extended Cost (line)" From an accounting perspective, it really should be NO different from purchase orders.…

in We are having discrepancies with our COGS account in the income statement vs the "Est. Extended Cost Comment by User_FZNHI Sep 23, 2020 5:29PM

Not at all. I can send you an excel example offline if that helps. Many thanks

in When we select Authorise Return on Sales Order - how can we ensure it equals the amount previously i Comment by User_FZNHI Sep 23, 2020 5:14PM

We did a simple script to handle our requirement as we receive orders 6 months in advance of shipping date. So those orders were imported in but a daily script ran each day reviewing todays vs required ship date and if it was less than xx days, then that line was made to be committed. Other wise it was not. I agree the…

in Capture Committed Date Comment by User_FZNHI Sep 22, 2020 5:11PM

Thanks as i am beginning to see the main issue here. If i ship a product on Dec 31st, my year end, the item fulfillment record created the entry Debit COGS Credit Inventory But if whatever reason I forget to invoice the customer - then I no longer have a matching of my COGS with Revenues... It sounds like from my review…

in We are having discrepancies with our COGS account in the income statement vs the "Est. Extended Cost Comment by User_FZNHI Sep 22, 2020 11:49AM

In Suiteanswers - search for Schema - this will give you the table structure. I find this most helpful. If you are doing a transaction saved search where the type is Sales Orders - you just look at that schema for that record type and it will explain what all the fields mean. Hope this helps.

in SQL of Saved Search and/or Report Comment by User_FZNHI Nov 7, 2019 5:41PM

MFA for Oracle Community

User_FZNHI Blue Ribbon

Comments