About mervz02

mervz02

Hi Experts,Im about to block Sales Order thru SP Notification, I Create a simple code to check if the customer has Open Invoices in the AR Module and if it does, it will block the sales order for that particular order unless the AR Document of the pr...

mervz02

Hi Experts, Im writing and developing a code for my Transaction Notification yet i cant figure it out anyone can help me, this is the details :I want to Block the Sales Order and Delivery with the following condition1. If there are previous AR Invoic...

mervz02

Hi Experts i create a UDF and a Query which compute number of days between two date using DATEDIFF and i want to show it to UDF Field, i setup it using FMS when AR Invoice due date field is change it will automatically compute to the UDF field the to...

mervz02

Hi Experts,I am about to do a simple task in my organization to block creating or updating or saving AR Invoices when due date and counter date is more than Customers Payment Terms + 10 Days. i have created simple Transaction Notification it fails to...

mervz02

I want to block an AR Invoice when the quantity and price is not equals to the Approved Document Draft, can you help me build the SP Notification for this one, tried some SQL Queries but it didn't work.

mervz02

Hi, Can you explain this code whats the difference from my code aside from connection into INV1? i tried the code it doesnt work

mervz02

Hi SonTran

mervz02

Hi, Yes Transaction Notification, i tried some query but it seems it blocks the AR Invoice without reference to SO. but i only want is to block the AR if the SO details in row is not match in AR Invoice. specially Quantiy.

mervz02

Hi Johan,When we cancel the document it creates automatically a cancellation document as well as respective journal entry to reflect the cancellation. its like credit memo but instead we cancel the document so that the goods or the documents will be ...

mervz02

Hi Johan,Thank you for the explanation, now i get it, and where using it already, but there is instances that we cannot cancel the document (A/R Cancellation) even we change the BP Reference in A/R Invoice its says the BP Invoice number is already ex...

User Statistics

User Activity

Blocking of Sales Order thru SP Transaction Notification

How to block Sales Order and Delivery when the previous AR Invoice Transaction is not yet paid

Why my User Defined Field does not refresh when other field changes

How to Block AR Invoice Based on Due Date and Counter Date

How to block AR Invoice not equals to Approved Document Draft

Re: Blocking of Sales Order thru SP Transaction Notification

Re: Blocking of Sales Order thru SP Transaction Notification

Re: Block AR Invoice not equals to Approve Sales Order Quantity

Re: Blocking of BP Reference Duplicate in AR Invoice

Re: Blocking of BP Reference Duplicate in AR Invoice