DynDeveloper.com

Where are email addresses stored in Dynamics GP?

It's not as straight forward as you might think...

I tried to create an Extender SQL Script Action today and couldn't get the syntax correct. 

In this article I show the correct code. 

We have a check stuck in "Work" status that is holding up payment on an entire batch.  Have reviewed similar issues in this forum & may well have missed a solution that would work here but for those I have tried, still not able to delete.  Either there is no Delete option, or data is greyed out or other but not able to delete this.  I have attached screen capture of the offending payment.  Any guidance sincerely appreciated.  

Thank you!  Andre 

Good afternoon,

I've been having an issue releasing a back order: every time we try to release, a warning comes up in regard of the creditor's limit being exceeded if we decide to proceed.

We've run the below query to find out the outstanding payments against the account:

select

*

from RM20101

where CUSTNMBR = custnumbr
and VOIDSTTS = 0
and CURTRXAM <> 0
and DINVPDOF = '01-01-1900'

This gives only one result.

The issue is that the unpaid invoice plus the back order that we are trying to release do not reach the credit limit that we've entered for the customer.

Please note that there is no other orders/invoices in the SOP10100 table but the above mentioned back order.

Is there something I'm not looking at that could breach the customer's credit limit?

The only thing that I can see is if I don't take in consideration the already applied markdown, the creditor's limit is exceeded, although the subtotal of the back order does take it in consideration.

Thank you for your help.

Hello :)

I am trying to create a PO using GP dynamic web Service. I found that the tax amount is zero (TAXAMNT field in both pop10100 and pop10110).

I tried to set the tax amount for each purchase line separately but the total tax amount for the header is zero and not calculated automatically.

I am getting the following error: 

Error: Unable to update/create the batch number

I need to find a way to undo an Add New Record in Radgrid.

So, a user adds a new record and moves off the new record row. That locks it in the grid (but has not yet been submitted to the underlying database).

How can I UNDO that via code (VB)?

I know that under normal circumstances, it would be better to run validation code and merely cancel the New Record before it locks in, but I have reasons for not doing that.

Conceptually, I think I just need a way to identify what the new record's ID is and then delete it. But, I can't figure out how to do that. I'm open to other solutions, as well.

I have this code that formats items in a list when a certain condition exists.

    Private Sub RadListFamilies_VisualItemFormatting(sender As Object, args As 

Telerik.WinControls.UI.VisualItemFormattingEventArgs) Handles RadListFamilies.VisualItemFormatting
        If isFamilyInProj(args.VisualItem.Data.Value) > 0 Then
            args.VisualItem.Font = fontBold
        End If
    End Sub

---

When I select an item in the list, I want to run that code. Currently, I have to select a different item and then click back on the original to refresh the formatting.

How can I force that without clicking out and back?