1

(5 replies, posted in Manufactoring)

Recently i discovered the bug maybe with some PHP versions about this, the way i fixed is changing it to this:

if (count($failed_item) > 0)
    {
           display_error(_("The issue cannot be processed because it would cause negative inventory balance for marked items as of document date or later."));
        return false;
    }

** Inside the IF statement i validate against the count() of the array instead just direct value.

Hope this helps.

2

(45 replies, posted in Modules Add-on's)

Hi Again, hope you are all doing well.

It's been a long time since the first release of Simple REST API, and lots of people asked me about a POS integration.

I made some spare time and i am working on a new light weight API and the integration with SynPOS 0.9.3, this is still a work in progress and many data is hardcoded (for example the customer id to sync orders) and lots of bugs still, but i wanted to let you know i am working on this and if there is anyone interested in helping with testing, coding or code review it will be appreciated, just let me know in this post or via email.

... Andres Amaya

Hi, the theme looks great, will you share the code to contribute?

4

(7 replies, posted in Modules Add-on's)

Hi, i've seen some posts about new themes wanted and also some posts about a mobile friendly theme.

I can invest some time trying to do a theme based on bootstrap, a responsive theme, what do you think?

But first i wanted to ask if anyone has already done something similar so we don't start from scratch or if any one else is interested working as a team.

Let me know smile Happy Coding!

5

(45 replies, posted in Modules Add-on's)

Hi, i am really sorry if i confuse with the Simple REST API for FA and another project on my github repo.

I created a branch of my Simple REST API for a client that wanted to connect FA and other Rails software with AutoFactura, so thats why i created the ruby gem for AutoFactura.

So for the Simple REST API i just changed the branch master with the help of Cambell Prince which send me a pull request that does not have anything additional.

6

(45 replies, posted in Modules Add-on's)

This is a JSON representation of the POST, hope this helps

{
  "trans_type": "10",
  "ref": "NoGuia0001",
  "customer_id": "4",
  "branch_id": "15",
  "location": "DEF",
  "deliver_to": "ABC, S.A. DE C.V.",
  "delivery_date": "2013-10-30",
  "delivery_address": "Calle., #2333 int: 0, Algo, C.P. 64420, Monterrey, Nuevo Leon, Estados Unidos Mexicanos",
  "phone": "",
  "cust_ref": "",
  "comments": "",
  "ship_via": "1",
  "payment": "5",
  "sales_type": "1",
  "items": [
    {
      "stock_id": "stock0001",   
      "description": "TRANSPORTE MTY-LAREDO",
      "qty": "1",
      "price": "100",
      "discount": "0"
    }
  ]
}

7

(45 replies, posted in Modules Add-on's)

Hi tm. Yes i noticed those bugs but i haven't got time to send it to github.com i probably will at the end of this week and let you know about those fixes.

There is also a bug on can_process:
/*if (!check_num('freight_cost', 0)) {
     return array("passed" => false, "message" => _("The shipping cost entered is expected to be numeric."));
   }*/
This should be commented because check_num verifies POST variable and with the API freight_cost is not a required field.

Let me see if i can send you later a POST example of an invoice.

8

(45 replies, posted in Modules Add-on's)

Hi, sorry about this, but i check the gitignore been missing and noticed that i made a big mistake when doing commit, here is the correct commit on github with IMPORTANT BUG FIXES:

http://github.com/andresamayadiaz/FrontAccountingSimpleAPI/commit/1361feb40343d6fd23d66e4b5383a727ef3eeb08

Sorry about this again. aad

9

(45 replies, posted in Modules Add-on's)

Hi, thanks.

I just noticed that my .gitignore file is missing i just added it again so those Mac specific files wont go to the repo.

I will be doing some final changes to the API and then start working on the mobile App using it, i'll keep you posted.

... aad

10

(45 replies, posted in Modules Add-on's)

Hi Again, i just pushed some new and great changes to the API, this is a brief description of the changes:

- Added .htaccess so you can now use API URL's without index.php, examples: (Thanks to Christian Estrella)
    OLD: GET http://mysystem.com/api/index.php/locations/
    NEW: GET http://mysystem.com/api/locations/

- Added Pagination to GET methods, it used to return all entries, now is per page, under index.php it has define("RESULTS_PER_PAGE", 2); that defines how many entries you will get per page, if you dont establish a page on the request you will get the first page. (Thanks to Christian Estrella)
    OLD Request: GET http://mysystem.com/api/index.php/locations/
    OLD Response: ALL LOCATIONS
   
    NEW Request 1: GET http://mysystem.com/api/index.php/locations/
    NEW Response 1: First Page of Locations
   
    NEW Request 2: GET http://mysystem.com/api/index.php/locations/?page=5
    NEW Response 2: Page 5 of Locations

- Added Sales Transactions Methods for Quotes, Sales Orders, Deliveries, Invoices (GET, PUT, POST)
    NOTE: This changes hasn't been tested deeply, might have some bugs

GitHub Commit ID: https://github.com/andresamayadiaz/FrontAccountingSimpleAPI/commit/b94360564f2bf80fe6d466d85767897351cee3de

Hope everybody likes the changes and if you can help me do some testing i will really appreciate that.

11

(38 replies, posted in Modules Add-on's)

I was just asking this, FA and vTiger what an awesome feature.
I dont think right now the best approach is FA into vTiger or the other way.

I've done some work with ETL using Talend Open Studio, maybe this could work. Create some Jobs like this:

1. Sync Products/Services from FA to vTiger ( to enable sync invoices )
2. Sync Accounts/Contacts from vTiger to FA ( to enable sync invoices )
3. Sync Invoices from vTiger to FA ( so that in FA you continue with payments etc .. )

Can be an option, right now i am working on releasing a final v1.0 SimpleAPI and then i was thinking on doing a mobile App iOS and Android for FA. I already got a starting UI design for this you can see it in this URL: https://docs.google.com/file/d/0B7PH8I10pJLZallxUEhvUTM1UVE/edit?usp=sharing

... aad

12

(45 replies, posted in Modules Add-on's)

The Repository has been updated with the BUG FIX.

... aad

13

(45 replies, posted in Modules Add-on's)

Thanks for this. I'll change it as soon as possible and let you know.

Andres

14

(45 replies, posted in Modules Add-on's)

Hi, that sounds great, just a question, PosXp needs .NET FrameWork, have you done some testing using Mono.NET ?

It would be great that the POS can be used in linux and mac as well.

.. aad

15

(45 replies, posted in Modules Add-on's)

As soon as i got some time i can work on an example client, probably using this: http://phphttpclient.com/ but for a quick testing you can use this: https://code.google.com/p/rest-client/ it is a REST Client, i am actually using this to test the Simple REST API.

About the POST and DELETE that depends on the HTTP Method used on the request, i wrote in a previous post that i am not using PUT requests this is not the standard REST and soon i am going to change it. You can get more information about CRUD operations in a REST API here: http://en.wikipedia.org/wiki/Create,_read,_update_and_delete

Also i want to comment that if any of you remember webERP they started some years ago to implement a JAVA POS using an API, they used synPOS, and maybe we can use this same POS (i have the source code) to create a POS system for FrontAccounting using Simple REST API and synPOS.

... aad

16

(45 replies, posted in Modules Add-on's)

Sorry about that, i just push the change to github.

... aad

17

(45 replies, posted in Modules Add-on's)

Hi again. Just wanted to keep you informed, i just publish some commits that now contains this methods in the API

GET /customers/:id/branches --> Get a list of customers branches where customer id = :id
GET /suppliers/:id/contacts --> Get a list of supplier contacts where supllier id = :id
GET /currencies/ --> Get a list fo currencies
GET /exrate/:id --> Get the latest currency rate with home currency where id = currency_code
GET /itemcosts/:id --> Get the standard cost of an item where id = :id
POST /itemcosts/:id --> Update the standard cost of an item where id = :id

... aad

18

(45 replies, posted in Modules Add-on's)

I just started working on this features for the API
GET /customers/:id/branches --> Get a list of customers branches where customer id = :id
GET /suppliers/:id/contacts --> Get a list of supplier contacts where supllier id = :id
POST /inventoryadjustments/ --> Create a new inventory adjustment ( can contain multiple items )

Then the roadmap will be:
GET /salesquotes/:id --> Get sales quote info
GET /salesorders/:id --> Get sales order info
POST /salesorders/ --> Create new sales order

NOTE: I am not using PUT requests, i replaced PUT requests with POST using id as parameter. I know this is not standard REST but works for me now, maybe in the future i can change it.

19

(38 replies, posted in Modules Add-on's)

I know this post is old but maybe my Simple Front Accounting REST API can help you, it is here:

https://github.com/andresamayadiaz/FrontAccountingSimpleAPI

... aad

20

(45 replies, posted in Modules Add-on's)

Hi all, i just released a simple REST API Module for Front Accounting.

I need to create some basic integration functions with another software so i created this public repository on GitHub.
I am using Slim FrameWork to create the REST API and trying to use FA Coding Standards.

Simple REST API Repository:
https://github.com/andresamayadiaz/FrontAccountingSimpleAPI

Hope you like it, i will be uploading changes as soon as i finish them, if you have any ideas or suggestions they are always welcome, and also if you find some bug, please let me know: andres.amaya.diaz@gmail.com