On Mon, Jul 6, 2009 at 7:09 AM, beamends <[email protected]> wrote:
> Hi all,
> I've been trying to create new rows from a C program. I can see the new
> rows from phppgadmin ok, but the records are not visible form LSMB (yes,
> I am using the right dbase!).
>
> Any ideas? Am I missing some vital field or something?
>
> The SQL is:
>
> INSERT INTO parts (id, partnumber, lastcost, sellprice, drawing,
> description, microfiche, income_accno_id, expense_accno_id,
> unit)
> VALUES (27791, '1013938', 1.86, 3.00, 'LAND ROVER800', 'PLUG - OIL
> DRAIN', '800', 10023, 10075, '1')
The above "part" is created as a "service" because it has no inventory
account associated with it. You should be able to pull it up under
Parts/Reports/Services.
For a part, you also need to set inventory_accno_id.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
